package com.woniu.mapper.sportsHealth;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.woniu.model.sportsHealth.entity.Step;
import com.woniu.model.sportsHealth.model.dto.StepDto;
import com.woniu.model.sportsHealth.model.vo.StepVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 步数表 Mapper 接口
 * </p>
 *
 * @author Jet
 * @since 2023-10-23
 */
@Mapper
public interface StepMapper extends BaseMapper<Step> {
    List<StepDto> findAll(Map<String,Object> param);

    @Select("select account,name,run_date,run_starttime,run_endtime,step_number,distance,consume from sh_step " +
            " inner join sh_user su on sh_step.sh_user_id = su.user_id")
    List<StepVo> findAllExport();
}
